#
# from selenium import webdriver
#
# wb=webdriver.Chrome()
# # print(dir(wb))
# wb.get('https://www.baidu.com')
#
# # for i in dir(wb):
# # /html/body/div[1]/div[1]/div[5]/div/div/div[3]/ul/li[2]/a/span[2]
# for i in wb.find_elements_by_class_name('title-content'):
#     # print(i.name())
#     print(i.get_attribute('text'))
#
#     # print(i.get_property('class'))

import xlrd


wb=xlrd.open_workbook(r'/home/m/2021年上半年推荐入团积极分子名单(1).xls')
ws=wb.sheet_by_name('member_info')
info_list=['bh','class','name','sfzh','address','telephone']
for rows in range(1,ws.nrows):
    mem_list=[ws.row(rows)[i].value for i in range(ws.ncols-1)]
    info_dict={info:mem for info,mem in zip(info_list,mem_list)}
    print(info_dict)

# for i in ws.get_rows():
#     print(i[0])
# for index in ws.nrows:
#     print(index)